package com.ideal.manage.esms.repository.project;

import com.ideal.manage.esms.bean.project.CategoryManage;
import com.ideal.manage.esms.repository.framework.BaseRepository;
import org.springframework.data.jpa.repository.Query;

import java.util.List;

public interface CategoryManageRepository extends BaseRepository<CategoryManage,String> {

    @Query("select c.code from CategoryManage c where c.isValid=1")
    List<CategoryManage> findCode();
    @Query("select c from CategoryManage c where c.isValid=1")
    List<CategoryManage> findByValid();
}
